EMT Practice Test

1. Question Content...

---

Question1: Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.

Question2: What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario?
There are 3 correct Answers to this question.

Question3: In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?

Question4: Which of the following events occur while the merge operation is running? There are 2 correct answers to this question.

Question5: Which of the following tools can be used for User Administration? There are 3 correct Answers to this question.

Question6: You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?

Question7: Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit?
There are 3 correct answers to this question.

Question8: You installed an SAP Netweaver-based application on an SAP HANA database. What is the default secure user store to store the password of the SAP<schema-id> user?

Question9: Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?
There are 2 correct answers in this question.

Question10: How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question.

Question11: Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question.

Question12: Which of the following actions are possible when managing roles? There are 3 correct answers to this question.

Question13: USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database?

Question14: How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

Question15: Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers.

Question16: Which parameters are mandatory when using the hdblcm tool in batch mode? There are 2 correct answers to this question.

Question17: You upgrade an SAP HANA 1.0 system to SAP HANA 2.0. Which of the following activities are required to avoid compatibility issues after the upgrade. Note: There are 2 correct answers.

Question18: Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit? There are 2 correct answers to this question.

Question19: SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log? There are 2 correct answers to this question.

Question20: The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?

Question21: What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers

Question22: Which package of SAP HANA cloud platform provides a vast set of platform services for the most common pattern in software engineering, such as persistence, connectivity, identity and document management?

Question23: The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

Question24: What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

Question25: Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? There are 3 correct answers to this question.

Question26: Your SAP HANA database is locked down. Which action can you still perform?

Question27: Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.

Question28: Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are
2 correct answers to this question.

Question29: You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default?

Question30: Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values?

Question31: What is the minimum space requirement for the Data Volume? There are 2 correct answers to this question.

Question32: Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There are 2 correct answers to this question.

Question33: Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? There are 2 correct answers to this question.

Question34: Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? There are 3 correct answers to this question.

Question35: Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to

Question36: How can you optimize the Database Migration Option (DMO) procedure downtime for a production system?
There are 2 correct answers to this question.

Question37: Which backup scenarios are allowed in multitenant database containers? Note: There are 2 correct answers.

Question38: For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

Question39: Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.

Question40: What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.

Question41: A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.

Question42: What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose

Question43: Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are 2 correct answers.

Question44: Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.

Question45: Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting?
Please choose the correct answer.

Question46: Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? There are 3 correct answers to this question.

Question47: Which option do you choose to protect your SAP HANA scale-out system using host autofailover?

Question48: Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.

Question49: SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.

Question50: Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.

Question51: You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system. Which of the following installation requirements are mandatory? There are 2 correct answers to this question.

Question52: Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.

Question53: Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.

Question54: You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration. Which steps take place during downtime?
There are 2 correct answers to this question.

Question55: What cryptographic libraries are supported in SAP HANA by default?
There are 2 correct answers to this question.

Question56: Which backup and recovery scenario is allowed in multitenant database containers?

Question57: What are the advantages of the DMO procedure? There are 3 correct answers to this question.

Question58: The recovery of your productive SAP HANA database fails during log replay. What is the fastest solution to complete the recovery.

Question59: In which replication mode is the primary system blocked until the secondary system is available?

Question60: Where do you investigate a failed uninstall of an SAP HANA scale-out system?

Question61: What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases?
There are 2 correct answers to this question.

Question62: Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question.

Question63: Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

Question64: Where is SDI used? There are 2 correct answers to this question.

Question65: After confirming Lock now, which actions are still possible? Choose the correct answer:.

Question66: Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive SAP HANA system.
Which tools can you use to monitor the system alerts of the SAP HANA database from your PC? There are 2 correct answers to this question.

Question67: You needt to integrate an existing SAP HANA2.0 SPS05 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?

Question68: Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer.

Question69: What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer.

Question70: When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question.

Question71: What is XS?

Question72: Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.

Question73: Which operating system process takes care of starting the SAP HANA database system services?
Please choose the correct answer.

Question74: Which tools are integrated into the SAP HANA cockpit?
There are 3 correct answers to this question.

Question75: To ensures that the database can be restored to the most recent committed state after a restart which of the following Indexserver components make sure such consistency and maintain durable changes?

Question76: How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.

Question77: What are prerequisites for changing the SSFS Master Keys? There are 2 correct answers to this question.

Question78: What is the correct sequence of the following four steps in the restart of the SAP HANA database system?
Please choose the correct answer.

Question79: Why are repository roles preferred over catalog roles? Note: There are 2 correct answers.

Question80: What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.

Question81: A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system privileges do you assign to the technical user account on the target system?

Question82: What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

Question83: Which parameters do you need to change before you can analyse the memory usage of running SQL statements? There are 2 correct answers to this question.

Question84: Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL?
There are 2 correct answers to this question.

Question85: You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT_MONITOR technical user?
There are 2 correct answers to this question.

Question86: In which situations can you resume the failed recovery of your productive SAP HANA tenant database?
There are 2 correct answers to this question.

Question87: Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question.

Question88: How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.

Question89: During the delta merge process, to which memory areas is data inserted? There are 2 correct Answers to this question.

Question90: Which SAP recommendations do you follow to create an optimal table partitioning plan for SAP Business Suite powered by SAP HANA? Note: There are 2 correct answers.

Question91: Which prerequisites are necessary for productively using SAP HANA cockpit 2.0?
There are 2 correct answers to this question.

Question92: How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system?
There are 2 correct answers to this question.

Question93: What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question.

Question94: Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?
There are 2 correct answers to this question.

Question95: Which actions take place during a database migration option (DMO) procedure when performing an in-place migration?
There are 2 correct answers to this question.

Question96: Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?
Please choose the correct answer.

Question97: Which of the following are characteristics of SAP HANA Smart Data Streaming?

Question98: You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which advanced DMO options can you adjust to speed up the migration? There are 2 correct answers to this question.

Question99: What must you do to convert an SAP HANA 1.0 single database system to an SAP HANA 2.0 multitenant database system?

Question100: Which tools do you use to delete diagnosis files? There are 2 correct answers to this question.

Question101: What is the recommended disk space for /hana/shared/<SID> for single-node SAP HANA systems? Please choose the correct answer:.

Question102: A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system privileges do you assign to the technical user account on the target system?